Flow Distinct
Short Description
Flow Distinct removes duplicate rows from its input
Detailed Description​
Flow Distinct scan the input and returns only non-duplicate rows. Whilst the Distinct operator consumes all the input before returning any data, Flow Distinct returns each row as it is obtained, unless it is a duplicate.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.